from sqlalchemy import Column
from sqlalchemy.dialects.oracle import VARCHAR2, NUMBER, DATE
from app.db.base import Base

# Program Date Entity
class ProgramDate(Base):
    __tablename__ = 'PROGRAM_DATE'
    __table_args__ = {'schema': 'IARO_CAREER'}

    program_code = Column(VARCHAR2(20), primary_key=True)
    program_year = Column(NUMBER)

    it1_start_date = Column(DATE)
    it1_weeks = Column(NUMBER)

    it2_start_date = Column(DATE)
    it2_weeks = Column(NUMBER)

    it3_start_date = Column(DATE)
    it3_weeks = Column(NUMBER)
